<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="VenueRequestLetters" targetNamespace="http://tempuri.org/VenueRequestLetters.xsd" xmlns:mstns="http://tempuri.org/VenueRequestLetters.xsd" xmlns="http://tempuri.org/VenueRequestLetters.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="PlacementManager" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="PlacementManager (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.PlacementManager.ConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dtVenueRequestLettersTableAdapter" Name="dtVenueRequestLetters">
            <MainSource>
              <DbSource ConnectionRef="PlacementManager (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Venue.VenueName, LinkVenueAddress.IsPrimary, Address.Address1, Address.Address2, Address.Street, Address.City, Address.PostCode, 
                      Geo_AdministrativeDivision.DivisionName, Geo_Country.CountryName, Contact.Title, Contact.FirstName, Contact.LastName, Unit.UnitCode, 
                      Unit.UnitName, Unit.YearLevel, Unit.UnitDescription, PlacementType.PlacementTypeName, PlacementType.Year, PlacementType.SemesterId, 
                      PlacementType.RequiredHours, PlacementType.DateStart, PlacementType.DateEnd
FROM         Venue INNER JOIN
                      LinkVenueAddress ON Venue.VenueId = LinkVenueAddress.VenueId INNER JOIN
                      Address ON LinkVenueAddress.AddressId = Address.AddressId INNER JOIN
                      Geo_AdministrativeDivision ON Address.StateId = Geo_AdministrativeDivision.AdministrativeDivisionID INNER JOIN
                      Geo_Country ON Address.CountryId = Geo_Country.CountryID INNER JOIN
                      LinkVenueContact ON Venue.VenueId = LinkVenueContact.VenueId INNER JOIN
                      Contact ON LinkVenueContact.ContactId = Contact.ContactId INNER JOIN
                      LinkVenueUnit ON Venue.VenueId = LinkVenueUnit.VenueId INNER JOIN
                      Unit ON LinkVenueUnit.UnitId = Unit.UnitId INNER JOIN
                      PlacementType ON Unit.UnitId = PlacementType.UnitId
WHERE     (Venue.IsActive = 1) AND (LinkVenueAddress.IsPrimary = 1) AND (Address.IsActive = 1) AND (LinkVenueContact.IsPrimary = 1) AND 
                      (LinkVenueUnit.IsActive = 1) AND (Unit.IsActive = 1) AND (PlacementType.IsActive = 1) AND (PlacementType.Year = 2008)</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VenueName" DataSetColumn="VenueName" />
              <Mapping SourceColumn="IsPrimary" DataSetColumn="IsPrimary" />
              <Mapping SourceColumn="Address1" DataSetColumn="Address1" />
              <Mapping SourceColumn="Address2" DataSetColumn="Address2" />
              <Mapping SourceColumn="Street" DataSetColumn="Street" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="PostCode" DataSetColumn="PostCode" />
              <Mapping SourceColumn="DivisionName" DataSetColumn="DivisionName" />
              <Mapping SourceColumn="CountryName" DataSetColumn="CountryName" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="UnitCode" DataSetColumn="UnitCode" />
              <Mapping SourceColumn="UnitName" DataSetColumn="UnitName" />
              <Mapping SourceColumn="YearLevel" DataSetColumn="YearLevel" />
              <Mapping SourceColumn="UnitDescription" DataSetColumn="UnitDescription" />
              <Mapping SourceColumn="PlacementTypeName" DataSetColumn="PlacementTypeName" />
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="SemesterId" DataSetColumn="SemesterId" />
              <Mapping SourceColumn="RequiredHours" DataSetColumn="RequiredHours" />
              <Mapping SourceColumn="DateStart" DataSetColumn="DateStart" />
              <Mapping SourceColumn="DateEnd" DataSetColumn="DateEnd" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="VenueRequestLetters" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="dtVenueRequestLetters">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VenueName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsPrimary" type="xs:boolean" />
              <xs:element name="Address1">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address2">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Street">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PostCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DivisionName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UnitCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UnitName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="YearLevel" type="xs:int" />
              <xs:element name="UnitDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PlacementTypeName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Year" type="xs:int" />
              <xs:element name="SemesterId" type="xs:int" />
              <xs:element name="RequiredHours" type="xs:int" />
              <xs:element name="DateStart" type="xs:dateTime" />
              <xs:element name="DateEnd" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>